version 17.0
clear
set more off

***		THIS MODULE USES THE CENSUS PULSE PUF WEEKLY DATA 	***

clear

cd "INSERT PATH TO WORKING DIRECTORY HERE"

import delimited using "pulse2020_puf_01", delimiter(",") varnames(1)  case(upper)

save "PULSE01.dta", replace

clear

import delimited using "pulse2020_puf_hhwgt_01", delimiter(",") varnames(1)  case(upper)
save "PULSE01_HHWGT.dta", replace

clear

import delimited using "pulse2020_repwgt_puf_01", delimiter(",") varnames(1)  case(upper)

save "PULSE01_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE01.dta", nogen
merge 1:1 SCRAM using "PULSE01_HHWGT.dta", nogen

save "PULSE01.dta", replace

clear

import delimited using "PULSE2020_puf_02", delimiter(",") varnames(1)  case(upper)

save "PULSE02.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_02", delimiter(",") varnames(1)  case(upper)

save "PULSE02_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_02", delimiter(",") varnames(1)  case(upper)
save "PULSE02_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE02.dta", nogen
merge 1:1 SCRAM using "PULSE02_HHWGT.dta", nogen

save "PULSE02.dta", replace

clear

import delimited using "PULSE2020_puf_03", delimiter(",") varnames(1)  case(upper)

save "PULSE03.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_03", delimiter(",") varnames(1)  case(upper)

save "PULSE03_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_03", delimiter(",") varnames(1)  case(upper)

save "PULSE03_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE03.dta", nogen
merge 1:1 SCRAM using "PULSE03_HHWGT.dta", nogen

save "PULSE03.dta", replace

clear

import delimited using "PULSE2020_puf_04", delimiter(",") varnames(1)  case(upper)

save "PULSE04.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_04", delimiter(",") varnames(1)  case(upper)


save "PULSE04_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_04", delimiter(",") varnames(1)  case(upper)

save "PULSE04_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE04.dta", nogen
merge 1:1 SCRAM using "PULSE04_HHWGT.dta", nogen

save "PULSE04.dta", replace

clear

import delimited using "PULSE2020_puf_05", delimiter(",") varnames(1)  case(upper)


save "PULSE05.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_05", delimiter(",") varnames(1)  case(upper)


save "PULSE05_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_05", delimiter(",") varnames(1)  case(upper)


save "PULSE05_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE05.dta", nogen
merge 1:1 SCRAM using "PULSE05_HHWGT.dta", nogen

save "PULSE05.dta", replace

clear

import delimited using "PULSE2020_puf_06", delimiter(",") varnames(1)  case(upper)


save "PULSE06.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_06", delimiter(",") varnames(1)  case(upper)


save "PULSE06_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_06", delimiter(",") varnames(1)  case(upper)


save "PULSE06_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE06.dta", nogen
merge 1:1 SCRAM using "PULSE06_HHWGT.dta", nogen

save "PULSE06.dta", replace

clear

import delimited using "PULSE2020_puf_07", delimiter(",") varnames(1)  case(upper)


save "PULSE07.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_07", delimiter(",") varnames(1)  case(upper)


save "PULSE07_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_07", delimiter(",") varnames(1)  case(upper)


save "PULSE07_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE07.dta", nogen
merge 1:1 SCRAM using "PULSE07_HHWGT.dta", nogen

save "PULSE07.dta", replace

clear

import delimited using "PULSE2020_puf_08", delimiter(",") varnames(1)  case(upper)


save "PULSE08.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_08", delimiter(",") varnames(1)  case(upper)


save "PULSE08_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_08", delimiter(",") varnames(1)  case(upper)


save "PULSE08_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE08.dta", nogen
merge 1:1 SCRAM using "PULSE08_HHWGT.dta", nogen

save "PULSE08.dta", replace

clear

import delimited using "PULSE2020_puf_09", delimiter(",") varnames(1)  case(upper)

save "PULSE09.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_09", delimiter(",") varnames(1)  case(upper)


save "PULSE09_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_09", delimiter(",") varnames(1)  case(upper)


save "PULSE09_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE09.dta", nogen
merge 1:1 SCRAM using "PULSE09_HHWGT.dta", nogen

save "PULSE09.dta", replace

clear

import delimited using "PULSE2020_puf_10", delimiter(",") varnames(1)  case(upper)


save "PULSE10.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_10", delimiter(",") varnames(1)  case(upper)


save "PULSE10_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_10", delimiter(",") varnames(1)  case(upper)
save "PULSE10_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE10.dta", nogen
merge 1:1 SCRAM using "PULSE10_HHWGT.dta", nogen
save "PULSE10.dta", replace

clear

import delimited using "PULSE2020_puf_11", delimiter(",") varnames(1)  case(upper)

save "PULSE11.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_11", delimiter(",") varnames(1)  case(upper)

save "PULSE11_HHWGT.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_11", delimiter(",") varnames(1)  case(upper)

save "PULSE11_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE11.dta", nogen
merge 1:1 SCRAM using "PULSE11_HHWGT.dta", nogen

save "PULSE11.dta", replace

clear

import delimited using "PULSE2020_puf_12", delimiter(",") varnames(1)  case(upper)

save "PULSE12.dta", replace

clear

import delimited using "PULSE2020_puf_hhwgt_12", delimiter(",") varnames(1)  case(upper)

save "PULSE12_HHWGT.dta", replace

clear
import delimited using "PULSE2020_repwgt_puf_12", delimiter(",") varnames(1)  case(upper)

save "PULSE12_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE12.dta", nogen
merge 1:1 SCRAM using "PULSE12_HHWGT.dta", nogen

save "PULSE12.dta", replace

clear

import delimited using "PULSE2020_puf_13", delimiter(",") varnames(1)  case(upper)

save "PULSE13.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_13", delimiter(",") varnames(1)  case(upper)

save "PULSE13_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE13.dta", nogen

save "PULSE13.dta", replace

clear

import delimited using "PULSE2020_puf_14", delimiter(",") varnames(1)  case(upper)

save "PULSE14.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_14", delimiter(",") varnames(1)  case(upper)

save "PULSE14_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE14.dta", nogen

save "PULSE14.dta", replace

clear

import delimited using "PULSE2020_puf_15", delimiter(",") varnames(1)  case(upper)

save "PULSE15.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_15", delimiter(",") varnames(1)  case(upper)

save "PULSE15_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE15.dta", nogen

save "PULSE15.dta", replace

clear

import delimited using "PULSE2020_puf_16", delimiter(",") varnames(1)  case(upper)

save "PULSE16.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_16", delimiter(",") varnames(1)  case(upper)

save "PULSE16_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE16.dta", nogen

save "PULSE16.dta", replace

clear

import delimited using "PULSE2020_puf_17", delimiter(",") varnames(1)  case(upper)

save "PULSE17.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_17", delimiter(",") varnames(1)  case(upper)
save "PULSE17_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE17.dta", nogen

save "PULSE17.dta", replace

clear

import delimited using "PULSE2020_puf_18", delimiter(",") varnames(1)  case(upper)

save "PULSE18.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_18", delimiter(",") varnames(1)  case(upper)

save "PULSE18_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE18.dta", nogen

save "PULSE18.dta", replace

clear

import delimited using "PULSE2020_puf_19", delimiter(",") varnames(1)  case(upper)

save "PULSE19.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_19", delimiter(",") varnames(1)  case(upper)

save "PULSE19_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE19.dta", nogen

save "PULSE19.dta", replace

clear

import delimited using "PULSE2020_puf_20", delimiter(",") varnames(1)  case(upper)

save "PULSE20.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_20", delimiter(",") varnames(1)  case(upper)

save "PULSE20_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE20.dta", nogen

save "PULSE20.dta", replace

clear

import delimited using "PULSE2020_puf_21", delimiter(",") varnames(1)  case(upper)

save "PULSE21.dta", replace

clear

import delimited using "PULSE2020_repwgt_puf_21", delimiter(",") varnames(1)  case(upper)

save "PULSE21_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE21.dta", nogen

save "PULSE21.dta", replace

clear

import delimited using "PULSE2021_puf_22", delimiter(",") varnames(1)  case(upper)

save "PULSE22.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_22", delimiter(",") varnames(1)  case(upper)

save "PULSE22_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE22.dta", nogen

save "PULSE22.dta", replace

clear

import delimited using "PULSE2021_puf_23", delimiter(",") varnames(1)  case(upper)

save "PULSE23.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_23", delimiter(",") varnames(1)  case(upper)

save "PULSE23_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE23.dta", nogen

save "PULSE23.dta", replace

clear

import delimited using "PULSE2021_puf_24", delimiter(",") varnames(1)  case(upper)

save "PULSE24.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_24", delimiter(",") varnames(1)  case(upper)
save "PULSE24_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE24.dta", nogen

save "PULSE24.dta", replace



clear

import delimited using "PULSE2021_puf_25", delimiter(",") varnames(1)  case(upper)

save "PULSE25.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_25", delimiter(",") varnames(1)  case(upper)

save "PULSE25_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE25.dta", nogen

save "PULSE25.dta", replace

clear

import delimited using "PULSE2021_puf_26", delimiter(",") varnames(1)  case(upper)

save "PULSE26.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_26", delimiter(",") varnames(1)  case(upper)

save "PULSE26_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE26.dta", nogen

save "PULSE26.dta", replace

clear

import delimited using "PULSE2021_puf_27", delimiter(",") varnames(1)  case(upper)
save "PULSE27.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_27", delimiter(",") varnames(1)  case(upper)

save "PULSE27_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE27.dta", nogen

save "PULSE27.dta", replace

clear

import delimited using "PULSE2021_puf_28", delimiter(",") varnames(1)  case(upper)

save "PULSE28.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_28", delimiter(",") varnames(1)  case(upper)

save "PULSE28_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE28.dta", nogen

save "PULSE28.dta", replace

clear

import delimited using "PULSE2021_puf_29", delimiter(",") varnames(1)  case(upper)

save "PULSE29.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_29", delimiter(",") varnames(1)  case(upper)

save "PULSE29_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE29.dta", nogen

save "PULSE29.dta", replace

clear

import delimited using "PULSE2021_puf_30", delimiter(",") varnames(1)  case(upper)

save "PULSE30.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_30", delimiter(",") varnames(1)  case(upper)

save "PULSE30_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE30.dta", nogen

save "PULSE30.dta", replace

clear

import delimited using "PULSE2021_puf_31", delimiter(",") varnames(1)  case(upper)

save "PULSE31.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_31", delimiter(",") varnames(1)  case(upper)

save "PULSE31_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE31.dta", nogen

save "PULSE31.dta", replace

clear

import delimited using "PULSE2021_puf_32", delimiter(",") varnames(1)  case(upper)

save "PULSE32.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_32", delimiter(",") varnames(1)  case(upper)

save "PULSE32_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE32.dta", nogen

save "PULSE32.dta", replace

clear

import delimited using "PULSE2021_puf_33", delimiter(",") varnames(1)  case(upper)

save "PULSE33.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_33", delimiter(",") varnames(1)  case(upper)

save "PULSE33_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE33.dta", nogen

save "PULSE33.dta", replace

clear

import delimited using "PULSE2021_puf_33", delimiter(",") varnames(1)  case(upper)

save "PULSE33.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_33", delimiter(",") varnames(1)  case(upper)

save "PULSE33_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE33.dta", nogen

save "PULSE33.dta", replace

clear

import delimited using "PULSE2021_puf_34", delimiter(",") varnames(1)  case(upper)

save "PULSE34.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_34", delimiter(",") varnames(1)  case(upper)

save "PULSE34_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE34.dta", nogen

save "PULSE34.dta", replace

clear

import delimited using "PULSE2021_puf_35", delimiter(",") varnames(1)  case(upper)

save "PULSE35.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_35", delimiter(",") varnames(1)  case(upper)

save "PULSE35_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE35.dta", nogen

save "PULSE35.dta", replace

clear

import delimited using "PULSE2021_puf_36", delimiter(",") varnames(1)  case(upper)
save "PULSE36.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_36", delimiter(",") varnames(1)  case(upper)

save "PULSE36_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE36.dta", nogen

save "PULSE36.dta", replace

clear

import delimited using "PULSE2021_puf_37", delimiter(",") varnames(1)  case(upper)

save "PULSE37.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_37", delimiter(",") varnames(1)  case(upper)

save "PULSE37_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE37.dta", nogen

save "PULSE37.dta", replace

clear

import delimited using "PULSE2021_puf_38", delimiter(",") varnames(1)  case(upper)

save "PULSE38.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_38", delimiter(",") varnames(1)  case(upper)

save "PULSE38_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE38.dta", nogen

save "PULSE38.dta", replace

clear

import delimited using "PULSE2021_puf_39", delimiter(",") varnames(1)  case(upper)

save "PULSE39.dta", replace

clear

import delimited using "PULSE2021_repwgt_puf_39", delimiter(",") varnames(1)  case(upper)

save "PULSE39_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE39.dta", nogen

save "PULSE39.dta", replace

clear

import delimited using "pulse2021_puf_40", delimiter(",") varnames(1)  case(upper)

save "PULSE40.dta", replace

clear

import delimited using "pulse2021_repwgt_puf_40", delimiter(",") varnames(1)  case(upper)

save "PULSE40_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE40.dta", nogen

save "PULSE40.dta", replace

clear

import delimited using "pulse2022_puf_41", delimiter(",") varnames(1)  case(upper)

save "PULSE41.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_41", delimiter(",") varnames(1)  case(upper)

save "PULSE41_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE41.dta", nogen

save "PULSE41.dta", replace

clear

import delimited using "pulse2022_puf_42", delimiter(",") varnames(1)  case(upper)

save "PULSE42.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_42", delimiter(",") varnames(1)  case(upper)

save "PULSE42_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE42.dta", nogen

save "PULSE42.dta", replace

clear

import delimited using "pulse2022_puf_43", delimiter(",") varnames(1)  case(upper)

save "PULSE43.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_43", delimiter(",") varnames(1)  case(upper)

save "PULSE43_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE43.dta", nogen

save "PULSE43.dta", replace

clear

import delimited using "pulse2022_puf_44", delimiter(",") varnames(1)  case(upper)

save "PULSE44.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_44", delimiter(",") varnames(1)  case(upper)

save "PULSE44_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE44.dta", nogen

save "PULSE44.dta", replace

clear

import delimited using "pulse2022_puf_45", delimiter(",") varnames(1)  case(upper)
save "PULSE45.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_45", delimiter(",") varnames(1)  case(upper)

save "PULSE45_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE45.dta", nogen

save "PULSE45.dta", replace

clear

import delimited using "pulse2022_puf_46", delimiter(",") varnames(1)  case(upper)

save "PULSE46.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_46", delimiter(",") varnames(1)  case(upper)

save "PULSE46_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE46.dta", nogen

save "PULSE46.dta", replace

clear

import delimited using "pulse2022_puf_47", delimiter(",") varnames(1)  case(upper)

save "PULSE47.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_47", delimiter(",") varnames(1)  case(upper)

save "PULSE47_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE47.dta", nogen

save "PULSE47.dta", replace

clear

import delimited using "pulse2022_puf_48", delimiter(",") varnames(1)  case(upper)
save "PULSE48.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_48", delimiter(",") varnames(1)  case(upper)

save "PULSE48_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE48.dta", nogen

save "PULSE48.dta", replace

clear

import delimited using "pulse2022_puf_49", delimiter(",") varnames(1)  case(upper)

save "PULSE49.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_49", delimiter(",") varnames(1)  case(upper)

save "PULSE49_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE49.dta", nogen

save "PULSE49.dta", replace

clear

import delimited using "pulse2022_puf_50", delimiter(",") varnames(1)  case(upper)
save "PULSE50.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_50", delimiter(",") varnames(1)  case(upper)

save "PULSE50_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE50.dta", nogen

save "PULSE50.dta", replace

clear

import delimited using "pulse2022_puf_51", delimiter(",") varnames(1)  case(upper)

save "PULSE51.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_51", delimiter(",") varnames(1)  case(upper)

save "PULSE51_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE51.dta", nogen

save "PULSE51.dta", replace

clear

import delimited using "pulse2022_puf_52", delimiter(",") varnames(1)  case(upper)

save "PULSE52.dta", replace

clear

import delimited using "pulse2022_repwgt_puf_52", delimiter(",") varnames(1)  case(upper)

save "PULSE52_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE52.dta", nogen

save "PULSE52.dta", replace

clear

import delimited using "pulse2023_puf_53", delimiter(",") varnames(1)  case(upper)

save "PULSE53.dta", replace

clear

import delimited using "pulse2023_repwgt_puf_53", delimiter(",") varnames(1)  case(upper)

save "PULSE53_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE53.dta", nogen

save "PULSE53.dta", replace

clear


import delimited using "pulse2023_puf_54", delimiter(",") varnames(1)  case(upper) numericcol(2/243)

save "PULSE54.dta", replace

clear

import delimited using "pulse2023_repwgt_puf_54", delimiter(",") varnames(1) case(upper) numericcol(2/162)

save "PULSE54_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE54.dta", nogen

save "PULSE54.dta", replace

clear

import delimited using "pulse2023_puf_55", delimiter(",") varnames(1)  case(upper) numericcol(2/244)

save "PULSE55.dta", replace

clear

import delimited using "pulse2023_repwgt_puf_55", delimiter(",") varnames(1) case(upper) numericcol(2/162)

save "PULSE55_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE55.dta", nogen

save "PULSE55.dta", replace

clear

import delimited using "pulse2023_puf_56", delimiter(",") varnames(1)  case(upper) numericcol(2/244)

save "PULSE56.dta", replace

clear

import delimited using "pulse2023_repwgt_puf_56", delimiter(",") varnames(1) case(upper) numericcol(2/162)

save "PULSE56_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE56.dta", nogen

save "PULSE56.dta", replace

clear

import delimited using "pulse2023_puf_57", delimiter(",") varnames(1)  case(upper) numericcol(2/244)

save "PULSE57.dta", replace

clear

import delimited using "pulse2023_repwgt_puf_57", delimiter(",") varnames(1) case(upper) numericcol(2/162)

save "PULSE57_REPWGT.dta", replace

merge 1:1 SCRAM using "PULSE57.dta", nogen

save "PULSE57.dta", replace

clear

use "PULSE01.dta", clear

append using "PULSE02.dta"
append using "PULSE03.dta"
append using "PULSE04.dta"
append using "PULSE05.dta"
append using "PULSE06.dta"
append using "PULSE07.dta"
append using "PULSE08.dta"
append using "PULSE09.dta"
append using "PULSE10.dta"
append using "PULSE11.dta"
append using "PULSE12.dta"
append using "PULSE13.dta"
append using "PULSE14.dta"
append using "PULSE15.dta"
append using "PULSE16.dta"
append using "PULSE17.dta"
append using "PULSE18.dta"
append using "PULSE19.dta"
append using "PULSE20.dta"
append using "PULSE21.dta"
append using "PULSE22.dta"
append using "PULSE23.dta"
append using "PULSE24.dta"
append using "PULSE25.dta"
append using "PULSE26.dta"
append using "PULSE27.dta"
append using "PULSE28.dta"
append using "PULSE29.dta"
append using "PULSE30.dta"
append using "PULSE31.dta"
append using "PULSE32.dta"
append using "PULSE33.dta"
append using "PULSE34.dta"
append using "PULSE35.dta"
append using "PULSE36.dta"
append using "PULSE37.dta"
append using "PULSE38.dta"
append using "PULSE39.dta"
append using "PULSE40.dta"
append using "PULSE41.dta"
append using "PULSE42.dta"
append using "PULSE43.dta"
append using "PULSE44.dta"
append using "PULSE45.dta"
append using "PULSE46.dta"
append using "PULSE47.dta"
append using "PULSE48.dta"
append using "PULSE49.dta"
append using "PULSE50.dta"
append using "PULSE51.dta"
append using "PULSE52.dta"
append using "PULSE53.dta"
append using "PULSE54.dta"
append using "PULSE55.dta"
append using "PULSE56.dta"
append using "PULSE57.dta"

compress

save "PULSE_without_lockdown_data.dta", replace
